﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_ProductProperty') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_ProductProperty
END
GO
	create View V_ProductProperty
	as
  SELECT A.ID,A.ProdGuid,B.PropName,A.PropValueName,B.OrderID
  FROM ShopNum1_ProductRelationProp A INNER JOIN ShopNum1_ProductProp B ON A.PropID=B.ID